Display-Based Problems in Spreadsheets: A Critical Incident and a Design Remedy

A critical incident is reported where a discretionary user needed to partition the spreadsheet grid into an arithmetic series of blocks and a p p l y a function to each, but was unable to devise a solution. The incident is first scrutinized to explicate the reasons for the failure. Then, a new method for progressional computation on tabular displays is described and reviewed for usability. The method increases the expressive power of cell referencing but also simplijes the notation. The spreadsheet is shown to be a surprisingly poor artefact for three classes of display-based problem.